if exists(select name from sysobjects where name = 'sp_ConfigGetInfo')
	drop proc sp_ConfigGetInfo
go
/*-- =============================================
	Created by: HP
	Created on: 2014-04-03 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_ConfigGetInfo.sql
*/-- =============================================

CREATE PROCEDURE sp_ConfigGetInfo
			
	@Id      		INT
AS
BEGIN	
	SELECT
		a.[Id],
		a.[Mail_Smtp],
		a.[Mail_Port],
		a.[Mail_Info],
		a.[Mail_Noreply],
		a.[Mail_Password],
		a.[PlaceHead],
		a.[PlaceBody],
		a.[GoogleId],
		a.[Contact],
		a.[DeliveryTerms],
		a.[PaymentTerms],
		a.[FreeShipping],
		a.[Copyright],
		a.[Title],
		a.[Description],
		a.[Keyword],
		a.[Lang],
		a.[Helpsize],
		a.[Location]
	FROM
		Config a
	WHERE
		    a.[Id]       = @Id;
END
GO
